Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 372140 |
| Missing cells | 58950 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 39.7 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "1.0" | Constant |
DATUM_BESTAND has constant value "2024-08-23 00:00:00" | Constant |
PEILDATUM has constant value "2024-08-01 00:00:00" | Constant |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with AANTAL_SUBTRAJECT_PER_SPC and 1 other fields | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 58950 (15.8%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.37810224) | Skewed |
Reproduction
| Analysis started | 2024-09-07 10:03:47.618745 |
|---|---|
| Analysis finished | 2024-09-07 10:04:02.010470 |
| Duration | 14.39 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1116420 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 372140 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 372140 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 372140 | |
| . | 372140 | |
| 0 | 372140 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1116420 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 372140 | |
| . | 372140 | |
| 0 | 372140 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1116420 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 372140 | |
| . | 372140 | |
| 0 | 372140 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1116420 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 372140 | |
| . | 372140 | |
| 0 | 372140 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2024-08-23 00:00:00 |
|---|---|
| Maximum | 2024-08-23 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2024-08-01 00:00:00 |
|---|---|
| Maximum | 2024-08-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
Histogram with fixed size bins (bins=13)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 462.22138 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1080.3317 |
|---|---|
| Coefficient of variation (CV) | 2.3372604 |
| Kurtosis | 50.162278 |
| Mean | 462.22138 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.2180502 |
| Sum | 1.7201106 × 108 |
| Variance | 1167116.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 51950 | |
| 313 | 48500 | |
| 303 | 42819 | |
| 330 | 29253 | 7.9% |
| 316 | 25120 | 6.8% |
| 308 | 20240 | 5.4% |
| 306 | 15643 | 4.2% |
| 324 | 15236 | 4.1% |
| 301 | 14821 | 4.0% |
| 304 | 12171 | 3.3% |
| Other values (18) | 96387 |
| Value | Count | Frequency (%) |
| 301 | 14821 | 4.0% |
| 302 | 8210 | 2.2% |
| 303 | 42819 | |
| 304 | 12171 | 3.3% |
| 305 | 51950 | |
| 306 | 15643 | 4.2% |
| 307 | 6581 | 1.8% |
| 308 | 20240 | 5.4% |
| 310 | 4068 | 1.1% |
| 313 | 48500 |
| Value | Count | Frequency (%) |
| 8418 | 5091 | 1.4% |
| 8416 | 1637 | 0.4% |
| 1900 | 247 | 0.1% |
| 390 | 1043 | 0.3% |
| 389 | 3899 | 1.0% |
| 362 | 4623 | 1.2% |
| 361 | 2731 | 0.7% |
| 335 | 3722 | 1.0% |
| 330 | 29253 | |
| 329 | 972 | 0.3% |
| Distinct | 1906 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.8 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3526012 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1247637 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 304 |
|---|---|
| 2nd row | 733 |
| 3rd row | 733 |
| 4th row | 733 |
| 5th row | 733 |
| Value | Count | Frequency (%) |
| 101 | 1601 | 0.4% |
| 402 | 1533 | 0.4% |
| 301 | 1505 | 0.4% |
| 403 | 1500 | 0.4% |
| 201 | 1432 | 0.4% |
| 203 | 1389 | 0.4% |
| 401 | 1250 | 0.3% |
| 404 | 1244 | 0.3% |
| 409 | 1216 | 0.3% |
| 302 | 1200 | 0.3% |
| Other values (1896) | 358270 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 238425 | |
| 0 | 229798 | |
| 2 | 165281 | |
| 3 | 134844 | |
| 5 | 96291 | |
| 9 | 89799 | 7.2% |
| 4 | 88237 | 7.1% |
| 7 | 73495 | 5.9% |
| 6 | 65043 | 5.2% |
| 8 | 53809 | 4.3% |
| Other values (15) | 12615 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1247637 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 238425 | |
| 0 | 229798 | |
| 2 | 165281 | |
| 3 | 134844 | |
| 5 | 96291 | |
| 9 | 89799 | 7.2% |
| 4 | 88237 | 7.1% |
| 7 | 73495 | 5.9% |
| 6 | 65043 | 5.2% |
| 8 | 53809 | 4.3% |
| Other values (15) | 12615 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1247637 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 238425 | |
| 0 | 229798 | |
| 2 | 165281 | |
| 3 | 134844 | |
| 5 | 96291 | |
| 9 | 89799 | 7.2% |
| 4 | 88237 | 7.1% |
| 7 | 73495 | 5.9% |
| 6 | 65043 | 5.2% |
| 8 | 53809 | 4.3% |
| Other values (15) | 12615 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1247637 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 238425 | |
| 0 | 229798 | |
| 2 | 165281 | |
| 3 | 134844 | |
| 5 | 96291 | |
| 9 | 89799 | 7.2% |
| 4 | 88237 | 7.1% |
| 7 | 73495 | 5.9% |
| 6 | 65043 | 5.2% |
| 8 | 53809 | 4.3% |
| Other values (15) | 12615 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6290 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.3989233 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99799062 |
| median | 1.4959902 × 108 |
| Q3 | 9.9000302 × 108 |
| 95-th percentile | 9.90616 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020396 × 108 |
Descriptive statistics
| Standard deviation | 4.2871187 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97458366 |
| Kurtosis | -1.7329685 |
| Mean | 4.3989233 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.47212231 |
| Sum | 1.6370153 × 1014 |
| Variance | 1.8379387 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2741 | 0.7% |
| 990004007 | 2686 | 0.7% |
| 990003004 | 2554 | 0.7% |
| 990004006 | 2163 | 0.6% |
| 990356076 | 1998 | 0.5% |
| 131999228 | 1899 | 0.5% |
| 131999164 | 1872 | 0.5% |
| 990356073 | 1838 | 0.5% |
| 131999194 | 1679 | 0.5% |
| 990003007 | 1631 | 0.4% |
| Other values (6280) | 351079 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 13 | |
| 10501004 | 13 | |
| 10501005 | 13 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 13 | |
| 10501010 | 13 | |
| 10501011 | 4 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 13 |
| Value | Count | Frequency (%) |
| 998418081 | 193 | |
| 998418080 | 175 | |
| 998418079 | 44 | < 0.1% |
| 998418077 | 10 | < 0.1% |
| 998418076 | 10 | < 0.1% |
| 998418075 | 8 | < 0.1% |
| 998418074 | 267 | |
| 998418073 | 265 | |
| 998418072 | 10 | < 0.1% |
| 998418071 | 10 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10851 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 513.99059 |
| Minimum | 1 |
|---|---|
| Maximum | 170328 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 101 |
| 95-th percentile | 1732 |
| Maximum | 170328 |
| Range | 170327 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 3208.0286 |
|---|---|
| Coefficient of variation (CV) | 6.2414152 |
| Kurtosis | 421.92663 |
| Mean | 513.99059 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.951146 |
| Sum | 1.9127646 × 108 |
| Variance | 10291448 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 62037 | 16.7% |
| 2 | 30166 | 8.1% |
| 3 | 19779 | 5.3% |
| 4 | 14407 | 3.9% |
| 5 | 11355 | 3.1% |
| 6 | 9535 | 2.6% |
| 7 | 7997 | 2.1% |
| 8 | 6692 | 1.8% |
| 9 | 6046 | 1.6% |
| 10 | 5431 | 1.5% |
| Other values (10841) | 198695 |
| Value | Count | Frequency (%) |
| 1 | 62037 | |
| 2 | 30166 | |
| 3 | 19779 | 5.3% |
| 4 | 14407 | 3.9% |
| 5 | 11355 | 3.1% |
| 6 | 9535 | 2.6% |
| 7 | 7997 | 2.1% |
| 8 | 6692 | 1.8% |
| 9 | 6046 | 1.6% |
| 10 | 5431 | 1.5% |
| Value | Count | Frequency (%) |
| 170328 | 1 | |
| 165181 | 1 | |
| 163753 | 1 | |
| 160960 | 1 | |
| 155866 | 1 | |
| 154635 | 1 | |
| 154254 | 1 | |
| 144709 | 1 | |
| 118398 | 1 | |
| 115934 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11739 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 611.78848 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 111 |
| 95-th percentile | 1981 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 108 |
Descriptive statistics
| Standard deviation | 4157.904 |
|---|---|
| Coefficient of variation (CV) | 6.7963097 |
| Kurtosis | 721.04331 |
| Mean | 611.78848 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.378102 |
| Sum | 2.2767097 × 108 |
| Variance | 17288166 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 59726 | 16.0% |
| 2 | 29659 | 8.0% |
| 3 | 19580 | 5.3% |
| 4 | 14189 | 3.8% |
| 5 | 11259 | 3.0% |
| 6 | 9498 | 2.6% |
| 7 | 7953 | 2.1% |
| 8 | 6605 | 1.8% |
| 9 | 5972 | 1.6% |
| 10 | 5431 | 1.5% |
| Other values (11729) | 202268 |
| Value | Count | Frequency (%) |
| 1 | 59726 | |
| 2 | 29659 | |
| 3 | 19580 | 5.3% |
| 4 | 14189 | 3.8% |
| 5 | 11259 | 3.0% |
| 6 | 9498 | 2.6% |
| 7 | 7953 | 2.1% |
| 8 | 6605 | 1.8% |
| 9 | 5972 | 1.6% |
| 10 | 5431 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231945 | 1 | |
| 230943 | 1 | |
| 227921 | 1 | |
| 227409 | 1 | |
| 226673 | 1 | |
| 223888 | 1 | |
| 218673 | 1 | |
| 216394 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9805 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7705.723 |
| Minimum | 1 |
|---|---|
| Maximum | 242378 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 38 |
| Q1 | 382 |
| median | 1678 |
| Q3 | 6243 |
| 95-th percentile | 37066 |
| Maximum | 242378 |
| Range | 242377 |
| Interquartile range (IQR) | 5861 |
Descriptive statistics
| Standard deviation | 18073.504 |
|---|---|
| Coefficient of variation (CV) | 2.3454651 |
| Kurtosis | 35.319006 |
| Mean | 7705.723 |
| Median Absolute Deviation (MAD) | 1541 |
| Skewness | 5.1319174 |
| Sum | 2.8676077 × 109 |
| Variance | 3.2665155 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9 | 644 | 0.2% |
| 21 | 623 | 0.2% |
| 8 | 591 | 0.2% |
| 25 | 586 | 0.2% |
| 26 | 571 | 0.2% |
| 23 | 570 | 0.2% |
| 2 | 561 | 0.2% |
| 4 | 561 | 0.2% |
| 12 | 561 | 0.2% |
| 5 | 554 | 0.1% |
| Other values (9795) | 366318 |
| Value | Count | Frequency (%) |
| 1 | 473 | |
| 2 | 561 | |
| 3 | 542 | |
| 4 | 561 | |
| 5 | 554 | |
| 6 | 554 | |
| 7 | 552 | |
| 8 | 591 | |
| 9 | 644 | |
| 10 | 473 |
| Value | Count | Frequency (%) |
| 242378 | 23 | |
| 232901 | 23 | |
| 230961 | 23 | |
| 227993 | 23 | |
| 218540 | 24 | |
| 214503 | 17 | |
| 213510 | 25 | |
| 211573 | 17 | |
| 210409 | 19 | |
| 205333 | 17 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10966 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11273.647 |
| Minimum | 1 |
|---|---|
| Maximum | 382003 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 507 |
| median | 2358 |
| Q3 | 9132.75 |
| 95-th percentile | 52858 |
| Maximum | 382003 |
| Range | 382002 |
| Interquartile range (IQR) | 8625.75 |
Descriptive statistics
| Standard deviation | 27334.111 |
|---|---|
| Coefficient of variation (CV) | 2.4246023 |
| Kurtosis | 38.328172 |
| Mean | 11273.647 |
| Median Absolute Deviation (MAD) | 2178 |
| Skewness | 5.3452743 |
| Sum | 4.1953751 × 109 |
| Variance | 7.4715363 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25 | 499 | 0.1% |
| 4 | 487 | 0.1% |
| 6 | 469 | 0.1% |
| 18 | 467 | 0.1% |
| 3 | 461 | 0.1% |
| 20 | 455 | 0.1% |
| 7 | 455 | 0.1% |
| 19 | 453 | 0.1% |
| 8 | 440 | 0.1% |
| 5 | 438 | 0.1% |
| Other values (10956) | 367516 |
| Value | Count | Frequency (%) |
| 1 | 382 | |
| 2 | 425 | |
| 3 | 461 | |
| 4 | 487 | |
| 5 | 438 | |
| 6 | 469 | |
| 7 | 455 | |
| 8 | 440 | |
| 9 | 421 | |
| 10 | 430 |
| Value | Count | Frequency (%) |
| 382003 | 23 | |
| 370337 | 23 | |
| 370126 | 23 | |
| 357268 | 23 | |
| 348469 | 25 | |
| 344894 | 24 | |
| 341641 | 19 | |
| 323740 | 20 | |
| 315768 | 17 | |
| 310747 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 352 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 668166.75 |
| Minimum | 1610 |
|---|---|
| Maximum | 1487618 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1610 |
|---|---|
| 5-th percentile | 39408 |
| Q1 | 249484 |
| median | 757875 |
| Q3 | 1027659 |
| 95-th percentile | 1339748 |
| Maximum | 1487618 |
| Range | 1486008 |
| Interquartile range (IQR) | 778175 |
Descriptive statistics
| Standard deviation | 422014.47 |
|---|---|
| Coefficient of variation (CV) | 0.63160053 |
| Kurtosis | -1.1885622 |
| Mean | 668166.75 |
| Median Absolute Deviation (MAD) | 319328 |
| Skewness | -0.027647979 |
| Sum | 2.4865157 × 1011 |
| Variance | 1.7809621 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880928 | 5102 | 1.4% |
| 874128 | 4354 | 1.2% |
| 843977 | 4347 | 1.2% |
| 894361 | 4333 | 1.2% |
| 880501 | 4273 | 1.1% |
| 897741 | 4212 | 1.1% |
| 765054 | 4089 | 1.1% |
| 814079 | 4048 | 1.1% |
| 804332 | 4031 | 1.1% |
| 1076547 | 3936 | 1.1% |
| Other values (342) | 329415 |
| Value | Count | Frequency (%) |
| 1610 | 130 | |
| 1831 | 138 | |
| 1922 | 131 | |
| 2495 | 173 | |
| 2632 | 193 | |
| 2715 | 79 | < 0.1% |
| 2748 | 60 | < 0.1% |
| 2890 | 255 | |
| 4024 | 301 | |
| 4325 | 82 | < 0.1% |
| Value | Count | Frequency (%) |
| 1487618 | 2975 | |
| 1450393 | 3048 | |
| 1421775 | 3564 | |
| 1344612 | 3543 | |
| 1340888 | 3441 | |
| 1339748 | 3413 | |
| 1332667 | 3545 | |
| 1316694 | 3463 | |
| 1283011 | 3576 | |
| 1269426 | 3354 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 353 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1094888.6 |
| Minimum | 1861 |
|---|---|
| Maximum | 2679230 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 1861 |
|---|---|
| 5-th percentile | 46148 |
| Q1 | 365016 |
| median | 1111817 |
| Q3 | 1804767 |
| 95-th percentile | 2601096 |
| Maximum | 2679230 |
| Range | 2677369 |
| Interquartile range (IQR) | 1439751 |
Descriptive statistics
| Standard deviation | 765686.55 |
|---|---|
| Coefficient of variation (CV) | 0.69932827 |
| Kurtosis | -0.83138142 |
| Mean | 1094888.6 |
| Median Absolute Deviation (MAD) | 701213 |
| Skewness | 0.34784541 |
| Sum | 4.0745185 × 1011 |
| Variance | 5.862759 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211827 | 5102 | 1.4% |
| 1281604 | 4354 | 1.2% |
| 1216288 | 4347 | 1.2% |
| 1315699 | 4333 | 1.2% |
| 1300575 | 4273 | 1.1% |
| 1342015 | 4212 | 1.1% |
| 1156077 | 4089 | 1.1% |
| 1230077 | 4048 | 1.1% |
| 1207155 | 4031 | 1.1% |
| 2679230 | 3936 | 1.1% |
| Other values (343) | 329415 |
| Value | Count | Frequency (%) |
| 1861 | 130 | |
| 2102 | 138 | |
| 2198 | 131 | |
| 2817 | 173 | |
| 2821 | 79 | < 0.1% |
| 2827 | 60 | < 0.1% |
| 2894 | 255 | |
| 3452 | 193 | |
| 4326 | 82 | < 0.1% |
| 4677 | 301 |
| Value | Count | Frequency (%) |
| 2679230 | 3936 | |
| 2677634 | 3795 | |
| 2672112 | 3866 | |
| 2626316 | 3788 | |
| 2601096 | 3843 | |
| 2555652 | 3890 | |
| 2493665 | 3923 | |
| 2486795 | 3851 | |
| 2183767 | 3757 | |
| 2066343 | 3810 |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3776 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 58950 |
| Missing (%) | 15.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3637.2894 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 145 |
| Q1 | 480 |
| median | 1250 |
| Q3 | 4210 |
| 95-th percentile | 13905 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3730 |
Descriptive statistics
| Standard deviation | 6576.1914 |
|---|---|
| Coefficient of variation (CV) | 1.8079924 |
| Kurtosis | 127.99444 |
| Mean | 3637.2894 |
| Median Absolute Deviation (MAD) | 1025 |
| Skewness | 6.7633701 |
| Sum | 1.1391627 × 109 |
| Variance | 43246294 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2091 | 0.6% |
| 105 | 2081 | 0.6% |
| 110 | 1821 | 0.5% |
| 185 | 1734 | 0.5% |
| 180 | 1678 | 0.5% |
| 140 | 1569 | 0.4% |
| 175 | 1553 | 0.4% |
| 125 | 1497 | 0.4% |
| 145 | 1477 | 0.4% |
| 165 | 1471 | 0.4% |
| Other values (3766) | 296218 | |
| (Missing) | 58950 | 15.8% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 671 | 0.2% |
| 95 | 717 | 0.2% |
| 100 | 1022 | |
| 105 | 2081 | |
| 110 | 1821 | |
| 115 | 1119 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 107395 | 4 | |
| 101270 | 8 |
| AANTAL_PAT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_SUBTRAJECT_PER_SPC | AANTAL_SUBTRAJECT_PER_ZPD | BEHANDELEND_SPECIALISME_CD | GEMIDDELDE_VERKOOPPRIJS | ZORGPRODUCT_CD | |
|---|---|---|---|---|---|---|---|---|---|
| AANTAL_PAT_PER_DIAG | 1.000 | 0.348 | 0.328 | 0.988 | 0.330 | 0.325 | -0.061 | 0.037 | -0.173 |
| AANTAL_PAT_PER_SPC | 0.348 | 1.000 | 0.086 | 0.364 | 0.962 | 0.089 | -0.532 | -0.001 | -0.358 |
| AANTAL_PAT_PER_ZPD | 0.328 | 0.086 | 1.000 | 0.326 | 0.093 | 0.996 | 0.008 | -0.297 | -0.138 |
| AANTAL_SUBTRAJECT_PER_DIAG | 0.988 | 0.364 | 0.326 | 1.000 | 0.363 | 0.327 | -0.055 | 0.046 | -0.204 |
| AANTAL_SUBTRAJECT_PER_SPC | 0.330 | 0.962 | 0.093 | 0.363 | 1.000 | 0.100 | -0.453 | -0.001 | -0.386 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.325 | 0.089 | 0.996 | 0.327 | 0.100 | 1.000 | 0.013 | -0.300 | -0.146 |
| BEHANDELEND_SPECIALISME_CD | -0.061 | -0.532 | 0.008 | -0.055 | -0.453 | 0.013 | 1.000 | 0.047 | 0.212 |
| GEMIDDELDE_VERKOOPPRIJS | 0.037 | -0.001 | -0.297 | 0.046 | -0.001 | -0.300 | 0.047 | 1.000 | 0.029 |
| ZORGPRODUCT_CD | -0.173 | -0.358 | -0.138 | -0.204 | -0.386 | -0.146 | 0.212 | 0.029 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 304 | 149599002 | 1 | 1 | 4284 | 7479 | 1079971 | 2601096 | 1135.0 |
| 1 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799008 | 71 | 71 | 3186 | 3842 | 1079971 | 2601096 | 2140.0 |
| 2 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799019 | 1857 | 1971 | 3186 | 3842 | 1079971 | 2601096 | 470.0 |
| 3 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 990003004 | 21 | 21 | 3186 | 3842 | 1079971 | 2601096 | 110.0 |
| 4 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799061 | 5 | 5 | 3186 | 3842 | 1079971 | 2601096 | 8550.0 |
| 5 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799009 | 3 | 3 | 3186 | 3842 | 1079971 | 2601096 | 375.0 |
| 6 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799022 | 1 | 1 | 3186 | 3842 | 1079971 | 2601096 | NaN |
| 7 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799028 | 1477 | 1724 | 3186 | 3842 | 1079971 | 2601096 | 180.0 |
| 8 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799023 | 44 | 44 | 3186 | 3842 | 1079971 | 2601096 | 5670.0 |
| 9 | 1.0 | 2024-08-23 | 2024-08-01 | 2018-01-01 | 313 | 733 | 99799063 | 1 | 1 | 3186 | 3842 | 1079971 | 2601096 | NaN |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372130 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 02 | 199199005 | 3 | 3 | 8094 | 9236 | 885677 | 1271070 | NaN |
| 372131 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701026 | 2940 | 3333 | 24639 | 30842 | 885677 | 1271070 | 285.0 |
| 372132 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701021 | 4 | 5 | 24639 | 30842 | 885677 | 1271070 | NaN |
| 372133 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701024 | 1014 | 1063 | 24639 | 30842 | 885677 | 1271070 | 430.0 |
| 372134 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701022 | 1 | 1 | 24639 | 30842 | 885677 | 1271070 | NaN |
| 372135 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701025 | 915 | 2077 | 24639 | 30842 | 885677 | 1271070 | 290.0 |
| 372136 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701020 | 2 | 2 | 24639 | 30842 | 885677 | 1271070 | NaN |
| 372137 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701023 | 137 | 143 | 24639 | 30842 | 885677 | 1271070 | 890.0 |
| 372138 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 990003002 | 2 | 2 | 24639 | 30842 | 885677 | 1271070 | 90.0 |
| 372139 | 1.0 | 2024-08-23 | 2024-08-01 | 2012-01-01 | 310 | 12 | 120701027 | 21211 | 24216 | 24639 | 30842 | 885677 | 1271070 | 125.0 |